Setting Index Properties

Use the Index Name edit box to set the index name.

To include field(s) in the index, click to open the editor for editing under Fields.

The Index Type dropdown list defines the type of the table index. Oracle Database provides several indexing schemes.

Non-unique
Non-unique indexes do not impose the restriction of unique indexes on the column values.

Unique
Unique indexes guarantee that no two rows of a table have duplicate values in the key column (or columns).

Bitmap
In a bitmap index, a bitmap for each key value is used instead of a list of rowids.

Parallel with degree
Parallel indexing can improve index performance when you have a large amount of data, and have multiple CPUs. Enter the degree that determines the number of separate indexing processes.

Schema
The schema in which to create the index.

Note:
To create an index in your own schema, at least one of the following conditions must be true:
To create an index in another schema, all of the following conditions must be true: